<%-- 
    Document   : accountingmanagervspp
    Created on : Feb 12, 2012, 10:34:53 PM
    Author     : Alex
--%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <style type="text/css">
body {
	background-color: #000;
	background-image: url(bg.jpg);
	background-repeat: repeat-x;
}
body,td,th {
	font-family: Verdana, Geneva, sans-serif;
	font-size: 7pt;
	color: #FFF;
}
h1 { font-family:Verdana, Geneva, sans-serif; font-size:24; text-align:center;}
h2 { font-family:Verdana, Geneva, sans-serif; font-size:11px; color:white;}
h3 { font-family:Verdana, Geneva, sans-serif; font-size:30; color:white; text-align:center;}

#menu{
    font: Verdana, Geneva, sans-serif;
    font-size: 10pt;
    color: white;
    position: absolute;
    top: 200px;
    left: 150px;
    text-align: left;
    font-style: bold;
}

#vspp{
    font: Verdana, Geneva, sans-serif;
    font-size: 10pt;
    color: white;
    position: absolute;
    top: 180px;
    left: 300px;
    text-align: left;
    font-style: bold;
}
   </style>
   <script language = "Javascript" type="text/javascript">

function OnBlurInput(blur){

			if(blur.value == "")
			{
		    blur.value = "";
			}

}

function OnBlurInputPass(blur){

			if(blur.value == "")
			{
		    blur.value = "";
			}

			if(blur.value == "Password" || blur.value == "Retype Password" )
			{
			blur.type = "text";
			blur.value = blur.defaultValue;
			}


}

function OnClickInput(click){

			if(click.value == click.defaultValue )
			{
				click.value = "";
			}


}

function OnClickInputPass(click){

			if(click.value == click.defaultValue )
			{
				click.value = "";
			}
			if(click.type == "text")
			{
			click.type = "password";

			}

}
</script>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>FooBar Bookstore</title>
               <%
        if(session.getAttribute("manager") == null){
            response.sendRedirect("index.jsp");
        }
        else{
        %> 
    </head>
    <body>
   
        
                        <%
    try {

String connectionURL = "jdbc:mysql://localhost:3306/mpmpmpm";
// declare a connection by using Connection interface
Connection connection = null;
/* declare object of Statement interface that is used for executing sql
statements. */
Statement statement = null;
// declare a resultset that uses as a table for output data from tha table.
ResultSet rs = null;
ResultSet rs2= null;
// Load JBBC driver "com.mysql.jdbc.Driver"
Class.forName("com.mysql.jdbc.Driver").newInstance();
/* Create a connection by using getConnection() method that takes parameters
of string type connection url, user name and password to connect to database.*/
connection = DriverManager.getConnection(connectionURL, "root", "1234");
/* createStatement() is used for create statement object that is used for
sending sql statements to the specified database. */
statement = connection.createStatement();
// sql query to retrieve values from the secified table.
%>

 

<%

String QueryString = "SELECT name,sales from product";
rs = statement.executeQuery(QueryString);



 %>

 <div id="vspp">
<%
while (rs.next()) {
%>

 Products: <%=rs.getString(3)%> Price: <%=rs.getString(2)%> </br>



<% } %>
<%
// close all the connections.
rs.close();
statement.close();
connection.close();
} catch (Exception ex) {
%>
</font>
<font size="+3" color="red"></b>
<%
out.println("Unable to connect to database.");
}
%> 


 </div>
        <h1>Accounting Manager View Sales Per Product Page</h1>
        <div id="menu">
            <h2> Accounting Manager Menu </h2></br> <% session.getAttribute("firstname");%> <%session.getAttribute("lastname");%>
            
            <strong><a href="accountingmanagervspp.jsp"><h2>View Sales per Product</h2></a><strong>
                 <strong><a href="accountingmanagervspt.jsp"><h2>View Sales per Product Type</h2></a><strong>
                 <strong><a href="accountingmanagervts.jsp"><h2>View Total Sales</h2></a><strong>
        <strong><a href="LogoutServlet"><h2>LOGOUT</h2></a></strong>
        <strong><a href="accountingmanager.jsp"><h2>Go back</h2></a>
        </div>
        
        
        
        
        
           <%
             }
         %>
    </body>
</html>
